[dbo].[BAECartItemUpdate]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECartItemUpdate

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@CartItemID	int	4
@UserID	varchar(64)	64
@ItemType	varchar(64)	64
@Created	datetime	8
@LastUpdated	datetime	8

SQL Script

create procedure [dbo].[BAECartItemUpdate] @CartItemID as
int,
    @UserID AS varchar(64),
    @ItemType AS varchar(64),
    @Created AS datetime,
    @LastUpdated AS datetime
AS
    UPDATE CartItem
    SET UserID = @UserID,
    ItemType = @ItemType,
    LastUpdated = @LastUpdated
    WHERE CartItemID = @CartItemID;

GO

Uses

[dbo].[CartItem]
dbo